package net.kesumu.yushabu.storage;

import android.provider.BaseColumns;

public class FriendContract {
    
    public static final String TEXT_TYPE = " TEXT";
    public static final String COMMA_SEP = ",";
    public static final String SQL_CREATE_ENTRY_FRIEND =
        "CREATE TABLE " + FriendEntry.TABLE_NAME + " (" +
        FriendEntry._ID + " INTEGER PRIMARY KEY," +
        FriendEntry.COLUMN_NAME_FRIENDID + TEXT_TYPE + COMMA_SEP +
        FriendEntry.COLUMN_NAME_FRIENDNAME + TEXT_TYPE + COMMA_SEP +
        FriendEntry.COLUMN_NAME_FRIENDYUYUCHATID + TEXT_TYPE + COMMA_SEP +
        FriendEntry.COLUMN_NAME_FRIENDPHOTOPATH + TEXT_TYPE + 
        " )";

    public static final String SQL_DELETE_ENTRY_FRIEND =
        "DROP TABLE IF EXISTS " + FriendEntry.TABLE_NAME;

    public FriendContract() {
    }
    
    public static abstract class FriendEntry implements BaseColumns {
        public static final String TABLE_NAME = "friend";
        public static final String COLUMN_NAME_FRIENDID = "friendId";
        public static final String COLUMN_NAME_FRIENDNAME = "friendName";
        public static final String COLUMN_NAME_FRIENDYUYUCHATID = "friendYuYuChatId";
        public static final String COLUMN_NAME_FRIENDPHOTOPATH = "friendPhotoPath";
    }

}
